Tables [dbo].[AsiNrdsQueue]
Properties
PropertyValue
HeapYes
Row Count0
Created11:53:56 AM Tuesday, December 13, 2011
Last Modified11:40:00 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes iAsiNrdsQueueID: IDIDvarchar(10)10
No
Directionnvarchar(20)40
Yes
NrdsIdvarchar(10)10
Yes
RecordTypevarchar(20)20
Yes
QueuedDateTimedatetime8
Yes
Indexes Indexes
NameColumns
iAsiNrdsQueueIDID
SQL Script
CREATE TABLE [dbo].[AsiNrdsQueue]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Direction] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NrdsId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RecordType] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QueuedDateTime] [datetime] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iAsiNrdsQueueID] ON [dbo].[AsiNrdsQueue] ([ID]) ON [PRIMARY]
GO
Uses